INSERT INTO Users(UserName, PasswordHash, PasswordSalt, Email, Enabled, DateCreated, DateLastLogin, DateLastActivity, DateLastPasswordChange, FacebookUsername, TwitterUsername) VALUES ('eth0','5BAA61E4C9B93F3F0682250B6CF8331B7EE68FD8','12345','eth0@ifc0nfig.com','true','20110323 00:00:00','20110323 00:00:00','20110323 00:00:00','20110323 00:00:00','eth0izzle','eth0izzle')
INSERT INTO Users(UserName, PasswordHash, PasswordSalt, Email, Enabled, DateCreated, DateLastLogin, DateLastActivity, DateLastPasswordChange, FacebookUsername, TwitterUsername) VALUES ('Luke','5BAA61E4C9B93F3F0682250B6CF8331B7EE68FD8','12345','luke@the-obc.co.uk','true','20110323 00:00:00','20110323 00:00:00','20110323 00:00:00','20110323 00:00:00',NULL,NULL)

INSERT
INTO	Categories(Name, CreatorId)
VALUES	('Test Category',1)

INSERT
INTO	Forums(Name,CategoryId,Description,CreatorId)
VALUES	('Test Forum',1,'Moo',1)

INSERT
INTO	Forums(Name,CategoryId,Description,CreatorId)
VALUES	('Another Forum',1,'Moo',1)

INSERT
INTO	Forums(Name,CategoryId,Description,CreatorId,ParentForumId)
VALUES	('Test Sub-Forum',1,'Moo',1,1)

INSERT
INTO	Threads(Name,ForumId,CreatorId,CreatedDate,Views)
VALUES	('Test Thread',1,1,'20110323 00:00:00',0)

INSERT
INTO	Posts(CreatorId,Body,ThreadId,CreatedDate,IsSpam)
VALUES	(1,'tmmmmmmmm',1,'20110323 00:00:00', 'False')

INSERT
INTO	Posts(CreatorId,Body,ThreadId,CreatedDate,IsSpam)
VALUES	(2,'moooo',1,'20110323 00:00:00','False')

INSERT
INTO	Tags(Name)
VALUES	('test')

INSERT
INTO	TagThread(Tags_Id, Threads_Id)
VALUES	(1,1)

INSERT INTO	Configurations("Key","Value","Type","Description") VALUES ('ForumName','SimpleForum','System.String','');
INSERT INTO	Configurations("Key","Value","Type","Description") VALUES ('AchievementsEnabled','True','System.Boolean','');
INSERT INTO	Configurations("Key","Value","Type","Description") VALUES ('ReputationEnabled','True','System.Boolean','');
INSERT INTO	Configurations("Key","Value","Type","Description") VALUES ('AvatarRelativePath','/Content/Uploads/Avatars','System.String','');
INSERT INTO Configurations("Key","Value","Type","Description") VALUES ('Theme', 'Default','System.String','Sets the current theme of the forum. Please make sure the theme exists physically');
INSERT INTO Configurations("Key","Value","Type","Description") VALUES ('EmailFromAddress', 'no-reply@simpleforum.com','System.String', '');
INSERT INTO Configurations("Key","Value","Type","Description") VALUES ('EmailServer', 'localhost','System.String', '');
INSERT INTO Configurations("Key","Value","Type","Description") VALUES ('OpenIDEnabled', 'True','System.Boolean', '');

INSERT INTO Achievements("Name", "Description") VALUES('NewbieAchievement', 'Create your first thread');
INSERT INTO Achievements("Name", "Description") VALUES('EditorAchievement', 'Your first edit');
INSERT INTO Achievements("Name", "Description") VALUES('CommentatorAchievement', 'Replied to 25 threads');
INSERT INTO Achievements("Name", "Description") VALUES('ComedianAchievement', 'Have 100 posts rated "funny"');
INSERT INTO Achievements("Name", "Description") VALUES('NeighbourhoodWatchAchievement', 'Reported 25 posts');

INSERT INTO Ratings("Name") VALUES('Informative');
INSERT INTO Ratings("Name") VALUES('Funny');
INSERT INTO Ratings("Name") VALUES('Controversial');
INSERT INTO Ratings("Name") VALUES('Useful');

INSERT INTO ReportReasons("Reason") VALUES('spam');
INSERT INTO ReportReasons("Reason") VALUES('abusive');
